Aminet 51/Aminet 51 (2002)(GTI - Schatztruhe)[!][Oct 2002].iso/Aminet/text/misc/CSV_Tool.lha/CSV-Tool/Exports/Monde.sql

Text File | 2002-07-26 | 6.1 KB | 563 lines

#
# SQL Script from 'Monde.csv'
#
# Host: localhost    Database: 'Database'
#--------------------------------------------------------
OPEN DATABASE Database;
#
# Table structure for table 'Monde'
#
CREATE TABLE Monde (
  ID FLOAT NOT NULL,
  Mond CHAR(16),
  Planet CHAR(16),
  Mittlere_Planetenentfernung FLOAT,
  Planetenumlaufzeit FLOAT,
  Mittlerer_Durchmesser CHAR(16),
  Mittlerer_Dichte FLOAT
);
INSERT INTO Monde VALUES (
  1,
  'Mond',
  'Erde',
  384400,
  27.3,
  '3476',
  3.3
);
INSERT INTO Monde VALUES (
  2,
  'Phobos',
  'Mars',
  9400,
  0.32,
  '28 x 22 x 18',
  1.9
);
INSERT INTO Monde VALUES (
  3,
  'Deimos',
  'Mars',
  23500,
  1.26,
  '16 x 12 x 10',
  2.1
);
INSERT INTO Monde VALUES (
  4,
  'Metis',
  'Jupiter',
  128000,
  0.3,
  '40',
  NULL
);
INSERT INTO Monde VALUES (
  5,
  'Adrastea',
  'Jupiter',
  129000,
  0.3,
  '24 x 20 x 16',
  NULL
);
INSERT INTO Monde VALUES (
  6,
  'Amalthea',
  'Jupiter',
  181300,
  0.5,
  '270 x 170 x 150',
  NULL
);
INSERT INTO Monde VALUES (
  7,
  'Thebe',
  'Jupiter',
  221900,
  0.68,
  '110 x ? x 90',
  NULL
);
INSERT INTO Monde VALUES (
  8,
  'Io',
  'Jupiter',
  421600,
  1.77,
  '3630',
  3.6
);
INSERT INTO Monde VALUES (
  9,
  'Europa',
  'Jupiter',
  670900,
  3.55,
  '3138',
  3.0
);
INSERT INTO Monde VALUES (
  10,
  'Ganymed',
  'Jupiter',
  1070000,
  7.16,
  '5262',
  1.
);
INSERT INTO Monde VALUES (
  11,
  'Kallisto',
  'Jupiter',
  1880000,
  16.69,
  '4800',
  1.8
);
INSERT INTO Monde VALUES (
  12,
  'Leda',
  'Jupiter',
  11094000,
  238.7,
  '10',
  NULL
);
INSERT INTO Monde VALUES (
  13,
  'Himalia',
  'Jupiter',
  11480000,
  250.6,
  '180',
  NULL
);
INSERT INTO Monde VALUES (
  14,
  'Lysithea',
  'Jupiter',
  11720000,
  259.2,
  '20',
  NULL
);
INSERT INTO Monde VALUES (
  15,
  'Elara',
  'Jupiter',
  11737000,
  259.7,
  '80',
  NULL
);
INSERT INTO Monde VALUES (
  16,
  'Ananke',
  'Jupiter',
  21200000,
  631,
  '20',
  NULL
);
INSERT INTO Monde VALUES (
  17,
  'Carme',
  'Jupiter',
  22600000,
  692,
  '30',
  NULL
);
INSERT INTO Monde VALUES (
  18,
  'Pasiphae',
  'Jupiter',
  23500000,
  735,
  '40',
  NULL
);
INSERT INTO Monde VALUES (
  19,
  'Sinope',
  'Jupiter',
  23700000,
  758,
  '30',
  NULL
);
INSERT INTO Monde VALUES (
  20,
  'Atlas',
  'Saturn',
  137700,
  0.6,
  '38 x ? x 26',
  NULL
);
INSERT INTO Monde VALUES (
  21,
  'Prometheus',
  'Saturn',
  139400,
  0.61,
  '140 x 100 x 74',
  NULL
);
INSERT INTO Monde VALUES (
  22,
  'Pandora',
  'Saturn',
  141700,
  0.63,
  '110 x 84 x 66',
  NULL
);
INSERT INTO Monde VALUES (
  23,
  'Epimetheus',
  'Saturn',
  151400,
  0.69,
  '140 x 120 x 100',
  NULL
);
INSERT INTO Monde VALUES (
  24,
  'Janus',
  'Saturn',
  151500,
  0.69,
  '220 x 10 x 160',
  1.4
);
INSERT INTO Monde VALUES (
  25,
  'Mimas',
  'Saturn',
  185500,
  0.94,
  '392',
  1.2
);
INSERT INTO Monde VALUES (
  26,
  'Enceladus',
  'Saturn',
  238000,
  1.37,
  '500',
  1.2
);
INSERT INTO Monde VALUES (
  27,
  'Tethys',
  'Saturn',
  294700,
  1.89,
  '1060',
  NULL
);
INSERT INTO Monde VALUES (
  28,
  'Telesto',
  'Saturn',
  294700,
  1.89,
  '? x 24 x 22',
  NULL
);
INSERT INTO Monde VALUES (
  29,
  'Calypso',
  'Saturn',
  294700,
  1.89,
  '30 x 24 x 16',
  NULL
);
INSERT INTO Monde VALUES (
  30,
  'Dione',
  'Saturn',
  377400,
  2.74,
  '1120',
  1.4
);
INSERT INTO Monde VALUES (
  31,
  'Helene',
  'Saturn',
  377400,
  2.74,
  '36 x 32 x 30',
  NULL
);
INSERT INTO Monde VALUES (
  32,
  'Rhea',
  'Saturn',
  572000,
  4.52,
  '1530',
  1.3
);
INSERT INTO Monde VALUES (
  33,
  'Titan',
  'Saturn',
  1221900,
  15.94,
  '5150',
  1.9
);
INSERT INTO Monde VALUES (
  34,
  'Hyperion',
  'Saturn',
  1481100,
  21.28,
  '350 x 234 x 200',
  NULL
);
INSERT INTO Monde VALUES (
  35,
  'Japetus',
  'Saturn',
  3561300,
  79.33,
  '1460',
  1.2
);
INSERT INTO Monde VALUES (
  36,
  'Phoebe',
  'Saturn',
  12954000,
  550.4,
  '220',
  NULL
);
INSERT INTO Monde VALUES (
  37,
  'Cordelia',
  'Uranus',
  49800,
  0.34,
  '50',
  NULL
);
INSERT INTO Monde VALUES (
  38,
  'Ophelia',
  'Uranus',
  53800,
  0.38,
  '50',
  NULL
);
INSERT INTO Monde VALUES (
  39,
  'Bianca',
  'Uranus',
  59200,
  0.43,
  '50',
  NULL
);
INSERT INTO Monde VALUES (
  40,
  'Cressida',
  'Uranus',
  61800,
  0.46,
  '60',
  NULL
);
INSERT INTO Monde VALUES (
  41,
  'Desdemona',
  'Uranus',
  62700,
  0.48,
  '60',
  NULL
);
INSERT INTO Monde VALUES (
  42,
  'Julia',
  'Uranus',
  64400,
  0.49,
  '80',
  NULL
);
INSERT INTO Monde VALUES (
  43,
  'Portia',
  'Uranus',
  66100,
  0.51,
  '80',
  NULL
);
INSERT INTO Monde VALUES (
  44,
  'Rosalind',
  'Uranus',
  69900,
  0.56,
  '60',
  NULL
);
INSERT INTO Monde VALUES (
  45,
  'Belinda',
  'Uranus',
  75300,
  0.62,
  '60',
  NULL
);
INSERT INTO Monde VALUES (
  46,
  'Puck',
  'Uranus',
  86000,
  0.76,
  '170',
  NULL
);
INSERT INTO Monde VALUES (
  47,
  'Miranda',
  'Uranus',
  129400,
  4.41,
  '562',
  1.3
);
INSERT INTO Monde VALUES (
  48,
  'Ariel',
  'Uranus',
  191000,
  2.52,
  '1153',
  1.6
);
INSERT INTO Monde VALUES (
  49,
  'Umbriel',
  'Uranus',
  266300,
  4.14,
  '1172',
  1.4
);
INSERT INTO Monde VALUES (
  50,
  'Titania',
  'Uranus',
  435900,
  8.71,
  '1580',
  1.6
);
INSERT INTO Monde VALUES (
  51,
  'Oberon',
  'Uranus',
  583500,
  13.46,
  '1524',
  1.5
);
INSERT INTO Monde VALUES (
  52,
  'Naiad',
  'Neptun',
  48200,
  0.3,
  '50',
  NULL
);
INSERT INTO Monde VALUES (
  53,
  'Thalassa',
  'Neptun',
  50000,
  0.31,
  '90',
  NULL
);
INSERT INTO Monde VALUES (
  54,
  'Despina',
  'Neptun',
  52500,
  0.33,
  '140',
  NULL
);
INSERT INTO Monde VALUES (
  55,
  'Galatea',
  'Neptun',
  62000,
  .4,
  '160',
  NULL
);
INSERT INTO Monde VALUES (
  56,
  'Larissa',
  'Neptun',
  73600,
  0.55,
  '210 x 190',
  NULL
);
INSERT INTO Monde VALUES (
  57,
  'Proteus',
  'Neptun',
  117600,
  1.12,
  '400',
  NULL
);
INSERT INTO Monde VALUES (
  58,
  'Triton',
  'Neptun',
  354600,
  5.88,
  '2720',
  2.0
);
INSERT INTO Monde VALUES (
  59,
  'Nereide',
  'Neptun',
  5510700,
  359.4,
  '340',
  2.0
);
INSERT INTO Monde VALUES (
  60,
  'Charon',
  'Pluto',
  19600,
  6.39,
  '1190',
  2.1
);
CLOSE DATABASE;
#
# End of table: 'Monde'
#